
-- Relationship Deletion
      
-- Table tblTechnology Fields
IF ( EXISTS( SELECT syso.id FROM sysconstraints sysc INNER JOIN sysobjects syso ON syso.id = sysc.id INNER JOIN sysobjects syso2 ON syso2.id = sysc.constid WHERE ( syso.name = 'tblTechnology' ) AND ( syso2.name = 'FK_Technology_ExpertiseLevel' ) ) )
   ALTER TABLE dbo.[tblTechnology] DROP CONSTRAINT [FK_Technology_ExpertiseLevel]
GO


-- Table tblGoal Fields
IF ( EXISTS( SELECT syso.id FROM sysconstraints sysc INNER JOIN sysobjects syso ON syso.id = sysc.id INNER JOIN sysobjects syso2 ON syso2.id = sysc.constid WHERE ( syso.name = 'tblGoal' ) AND ( syso2.name = 'FK_Goal_Status' ) ) )
   ALTER TABLE dbo.[tblGoal] DROP CONSTRAINT [FK_Goal_Status]
GO


-- Table tblGoalRequiredExpertise Fields
IF ( EXISTS( SELECT syso.id FROM sysconstraints sysc INNER JOIN sysobjects syso ON syso.id = sysc.id INNER JOIN sysobjects syso2 ON syso2.id = sysc.constid WHERE ( syso.name = 'tblGoalRequiredExpertise' ) AND ( syso2.name = 'FK_GoalRequiredExpertise_Goal' ) ) )
   ALTER TABLE dbo.[tblGoalRequiredExpertise] DROP CONSTRAINT [FK_GoalRequiredExpertise_Goal]
GO

IF ( EXISTS( SELECT syso.id FROM sysconstraints sysc INNER JOIN sysobjects syso ON syso.id = sysc.id INNER JOIN sysobjects syso2 ON syso2.id = sysc.constid WHERE ( syso.name = 'tblGoalRequiredExpertise' ) AND ( syso2.name = 'FK_GoalRequiredExpertise_Technology' ) ) )
   ALTER TABLE dbo.[tblGoalRequiredExpertise] DROP CONSTRAINT [FK_GoalRequiredExpertise_Technology]
GO

